class PopulateGeoInfo < ActiveRecord::Migration
  def self.up
    execute "INSERT INTO provinces (name) VALUES ('Stockholm');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Upplands-Väsby',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vallentuna',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Österåker',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Värmdö',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Järfälla',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ekerö',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Huddinge',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Botkyrka',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Salem',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Haninge',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Tyresö',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Upplands-Bro',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Nykvarn',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Täby',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Danderyd',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Sollentuna',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Stockholm',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Södertälje',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Nacka',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Solna',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Lidingö',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vaxholm',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Norrtälje',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Sigtuna',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Nynäshamn',(SELECT id FROM provinces WHERE name='Stockholm'));"
    execute "INSERT INTO provinces (name) VALUES ('Uppsala');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Håbo',(SELECT id FROM provinces WHERE name='Uppsala'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Älvkarleby',(SELECT id FROM provinces WHERE name='Uppsala'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Knivsta',(SELECT id FROM provinces WHERE name='Uppsala'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Tierp',(SELECT id FROM provinces WHERE name='Uppsala'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Uppsala',(SELECT id FROM provinces WHERE name='Uppsala'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Enköping',(SELECT id FROM provinces WHERE name='Uppsala'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Östhammar',(SELECT id FROM provinces WHERE name='Uppsala'));"
    execute "INSERT INTO provinces (name) VALUES ('Södermanland');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vingåker',(SELECT id FROM provinces WHERE name='Södermanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Gnesta',(SELECT id FROM provinces WHERE name='Södermanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Nyköping',(SELECT id FROM provinces WHERE name='Södermanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Oxelösund',(SELECT id FROM provinces WHERE name='Södermanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Flen',(SELECT id FROM provinces WHERE name='Södermanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Katrineholm',(SELECT id FROM provinces WHERE name='Södermanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Eskilstuna',(SELECT id FROM provinces WHERE name='Södermanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Strängnäs',(SELECT id FROM provinces WHERE name='Södermanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Trosa',(SELECT id FROM provinces WHERE name='Södermanland'));"
    execute "INSERT INTO provinces (name) VALUES ('Östergötland');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ödeshög',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ydre',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kinda',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Boxholm',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Åtvidaberg',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Finspång',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Valdemarsvik',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Linköping',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Norrköping',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Söderköping',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Motala',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vadstena',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Mjölby',(SELECT id FROM provinces WHERE name='Östergötland'));"
    execute "INSERT INTO provinces (name) VALUES ('Jönköping');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Aneby',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Gnosjö',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Mullsjö',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Habo',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Gislaved',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vaggeryd',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Jönköping',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Nässjö',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Värnamo',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Sävsjö',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vetlanda',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Eksjö',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Tranås',(SELECT id FROM provinces WHERE name='Jönköping'));"
    execute "INSERT INTO provinces (name) VALUES ('Kronoberg');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Uppvidinge',(SELECT id FROM provinces WHERE name='Kronoberg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Lessebo',(SELECT id FROM provinces WHERE name='Kronoberg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Tingsryd',(SELECT id FROM provinces WHERE name='Kronoberg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Alvesta',(SELECT id FROM provinces WHERE name='Kronoberg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Älmhult',(SELECT id FROM provinces WHERE name='Kronoberg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Markaryd',(SELECT id FROM provinces WHERE name='Kronoberg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Växjö',(SELECT id FROM provinces WHERE name='Kronoberg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ljungby',(SELECT id FROM provinces WHERE name='Kronoberg'));"
    execute "INSERT INTO provinces (name) VALUES ('Kalmar');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Högsby',(SELECT id FROM provinces WHERE name='Kalmar'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Torsås',(SELECT id FROM provinces WHERE name='Kalmar'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Mörbylånga',(SELECT id FROM provinces WHERE name='Kalmar'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hultsfred',(SELECT id FROM provinces WHERE name='Kalmar'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Mönsterås',(SELECT id FROM provinces WHERE name='Kalmar'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Emmaboda',(SELECT id FROM provinces WHERE name='Kalmar'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kalmar',(SELECT id FROM provinces WHERE name='Kalmar'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Nybro',(SELECT id FROM provinces WHERE name='Kalmar'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Oskarshamn',(SELECT id FROM provinces WHERE name='Kalmar'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Västervik',(SELECT id FROM provinces WHERE name='Kalmar'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vimmerby',(SELECT id FROM provinces WHERE name='Kalmar'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Borgholm',(SELECT id FROM provinces WHERE name='Kalmar'));"
    execute "INSERT INTO provinces (name) VALUES ('Gotland');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Gotland',(SELECT id FROM provinces WHERE name='Gotland'));"
    execute "INSERT INTO provinces (name) VALUES ('Blekinge');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Olofström',(SELECT id FROM provinces WHERE name='Blekinge'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Karlskrona',(SELECT id FROM provinces WHERE name='Blekinge'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ronneby',(SELECT id FROM provinces WHERE name='Blekinge'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Karlshamn',(SELECT id FROM provinces WHERE name='Blekinge'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Sölvesborg',(SELECT id FROM provinces WHERE name='Blekinge'));"
    execute "INSERT INTO provinces (name) VALUES ('Skåne');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Svalöv',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Staffanstorp',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Burlöv',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vellinge',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Östra Göinge',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Örkelljunga',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Bjuv',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kävlinge',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Lomma',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Svedala',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Skurup',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Sjöbo',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hörby',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Höör',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Tomelilla',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Bromölla',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Osby',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Perstorp',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Klippan',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Åstorp',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Båstad',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Malmö',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Lund',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Landskrona',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Helsingborg',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Höganäs',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Eslöv',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ystad',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Trelleborg',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kristianstad',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Simrishamn',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ängelholm',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hässleholm',(SELECT id FROM provinces WHERE name='Skåne'));"
    execute "INSERT INTO provinces (name) VALUES ('Halland');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hylte',(SELECT id FROM provinces WHERE name='Halland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Halmstad',(SELECT id FROM provinces WHERE name='Halland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Laholm',(SELECT id FROM provinces WHERE name='Halland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Falkenberg',(SELECT id FROM provinces WHERE name='Halland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Varberg',(SELECT id FROM provinces WHERE name='Halland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kungsbacka',(SELECT id FROM provinces WHERE name='Halland'));"
    execute "INSERT INTO provinces (name) VALUES ('Västra Götaland');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Härryda',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Partille',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Öckerö',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Stenungsund',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Tjörn',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Orust',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Sotenäs',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Munkedal',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Tanum',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Dals-Ed',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Färgelanda',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ale',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Lerum',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vårgårda',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Bollebygd',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Grästorp',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Essunga',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Karlsborg',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Gullspång',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Tranemo',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Bengtsfors',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Mellerud',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Lilla Edet',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Svenljunga',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Herrljunga',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vara',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Götene',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Tibro',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Töreboda',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Göteborg',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Mölndal',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kungälv',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Lysekil',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Uddevalla',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Strömstad',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vänersborg',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Trollhättan',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Alingsås',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Borås',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ulricehamn',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Åmål',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Mariestad',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Lidköping',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Skara',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Skövde',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hjo',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Tidaholm',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Falköping',(SELECT id FROM provinces WHERE name='Västra Götaland'));"
    execute "INSERT INTO provinces (name) VALUES ('Värmland');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kil',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Eda',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Torsby',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Storfors',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hammarö',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Munkfors',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Forshaga',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Grums',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Årjäng',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Sunne',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Karlstad',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kristinehamn',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Filipstad',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hagfors',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Arvika',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Säffle',(SELECT id FROM provinces WHERE name='Värmland'));"
    execute "INSERT INTO provinces (name) VALUES ('Örebro');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Lekeberg',(SELECT id FROM provinces WHERE name='Örebro'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Laxå',(SELECT id FROM provinces WHERE name='Örebro'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hallsberg',(SELECT id FROM provinces WHERE name='Örebro'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Degerfors',(SELECT id FROM provinces WHERE name='Örebro'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hällefors',(SELECT id FROM provinces WHERE name='Örebro'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ljusnarsberg',(SELECT id FROM provinces WHERE name='Örebro'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Örebro',(SELECT id FROM provinces WHERE name='Örebro'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kumla',(SELECT id FROM provinces WHERE name='Örebro'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Askersund',(SELECT id FROM provinces WHERE name='Örebro'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Karlskoga',(SELECT id FROM provinces WHERE name='Örebro'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Nora',(SELECT id FROM provinces WHERE name='Örebro'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Lindesberg',(SELECT id FROM provinces WHERE name='Örebro'));"
    execute "INSERT INTO provinces (name) VALUES ('Västmanland');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Skinnskatteberg',(SELECT id FROM provinces WHERE name='Västmanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Surahammar',(SELECT id FROM provinces WHERE name='Västmanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Heby',(SELECT id FROM provinces WHERE name='Västmanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kungsör',(SELECT id FROM provinces WHERE name='Västmanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hallstahammar',(SELECT id FROM provinces WHERE name='Västmanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Norberg',(SELECT id FROM provinces WHERE name='Västmanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Västerås',(SELECT id FROM provinces WHERE name='Västmanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Sala',(SELECT id FROM provinces WHERE name='Västmanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Fagersta',(SELECT id FROM provinces WHERE name='Västmanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Köping',(SELECT id FROM provinces WHERE name='Västmanland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Arboga',(SELECT id FROM provinces WHERE name='Västmanland'));"
    execute "INSERT INTO provinces (name) VALUES ('Dalarna');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vansbro',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Malung',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Gagnef',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Leksand',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Rättvik',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Orsa',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Älvdalen',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Smedjebacken',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Mora',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Falun',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Borlänge',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Säter',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hedemora',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Avesta',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ludvika',(SELECT id FROM provinces WHERE name='Dalarna'));"
    execute "INSERT INTO provinces (name) VALUES ('Gävleborg');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ockelbo',(SELECT id FROM provinces WHERE name='Gävleborg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hofors',(SELECT id FROM provinces WHERE name='Gävleborg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ovanåker',(SELECT id FROM provinces WHERE name='Gävleborg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Nordanstig',(SELECT id FROM provinces WHERE name='Gävleborg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ljusdal',(SELECT id FROM provinces WHERE name='Gävleborg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Gävle',(SELECT id FROM provinces WHERE name='Gävleborg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Sandviken',(SELECT id FROM provinces WHERE name='Gävleborg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Söderhamn',(SELECT id FROM provinces WHERE name='Gävleborg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Bollnäs',(SELECT id FROM provinces WHERE name='Gävleborg'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Hudiksvall',(SELECT id FROM provinces WHERE name='Gävleborg'));"
    execute "INSERT INTO provinces (name) VALUES ('Västernorrland');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ånge',(SELECT id FROM provinces WHERE name='Västernorrland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Timrå',(SELECT id FROM provinces WHERE name='Västernorrland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Härnösand',(SELECT id FROM provinces WHERE name='Västernorrland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Sundsvall',(SELECT id FROM provinces WHERE name='Västernorrland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kramfors',(SELECT id FROM provinces WHERE name='Västernorrland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Sollefteå',(SELECT id FROM provinces WHERE name='Västernorrland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Örnsköldsvik',(SELECT id FROM provinces WHERE name='Västernorrland'));"
    execute "INSERT INTO provinces (name) VALUES ('Jämtland');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Ragunda',(SELECT id FROM provinces WHERE name='Jämtland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Bräcke',(SELECT id FROM provinces WHERE name='Jämtland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Krokom',(SELECT id FROM provinces WHERE name='Jämtland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Strömsund',(SELECT id FROM provinces WHERE name='Jämtland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Åre',(SELECT id FROM provinces WHERE name='Jämtland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Berg',(SELECT id FROM provinces WHERE name='Jämtland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Härjedalen',(SELECT id FROM provinces WHERE name='Jämtland'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Östersund',(SELECT id FROM provinces WHERE name='Jämtland'));"
    execute "INSERT INTO provinces (name) VALUES ('Västerbotten');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Nordmaling',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Bjurholm',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vindeln',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Robertsfors',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Norsjö',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Malå',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Storuman',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Sorsele',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Dorotea',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vännäs',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Vilhelmina',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Åsele',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Umeå',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Lycksele',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Skellefteå',(SELECT id FROM provinces WHERE name='Västerbotten'));"
    execute "INSERT INTO provinces (name) VALUES ('Norrbotten');"
    execute "INSERT INTO counties (name,province_id) VALUES ('Arvidsjaur',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Arjeplog',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Jokkmokk',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Överkalix',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kalix',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Övertorneå',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Pajala',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Gällivare',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Älvsbyn',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Luleå',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Piteå',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Boden',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Haparanda',(SELECT id FROM provinces WHERE name='Norrbotten'));"
    execute "INSERT INTO counties (name,province_id) VALUES ('Kiruna',(SELECT id FROM provinces WHERE name='Norrbotten'));"
  end

  def self.down
  end
end
